{smcl}
{com}{sf}{ul off}{txt}{.-}
      name:  {res}<unnamed>
       {txt}log:  {res}\\file\UsersW$\wrr15\Home\My Documents\My Files\ATANDA AKINWANDE\BCD PAPER\HEALTH ECONOMICS revision\NEW DATA AND PROGRAMS (20171021)\TABLE1.smcl
  {txt}log type:  {res}smcl
 {txt}opened on:  {res} 9 Nov 2017, 09:54:21
{txt}
{com}. use "\\file\UsersW$\wrr15\Home\My Documents\My Files\ATANDA AKINWANDE\BCD PAPER\HEALTH ECONOMICS revision\NEW DATA AND PROGRAMS (20171021)\BCD_dataset_09_11_2017", clear
{txt}
{com}. 
. //ge phpnh = 100*phn
. //ge lhl = 100*lhsl
. 
. summ phpnh lhl prod k pop14 pop65 male lex infmo tobaco alcohc gdpg

{txt}    Variable {c |}        Obs        Mean    Std. Dev.       Min        Max
{hline 13}{c +}{hline 57}
{space 7}phpnh {c |}{res}        503    99.84826    15.94281   51.52672   197.6775
{txt}{space 9}lhl {c |}{res}        392    9.943161    4.093125   2.146441   20.12945
{txt}{space 8}prod {c |}{res}        585    41.64198    16.01424   11.36031   97.53915
{txt}{space 11}k {c |}{res}        602    90.88357    2.551716     82.671    96.0033
{txt}{space 7}pop14 {c |}{res}        616     17.8707    3.052274   12.99632   32.13839
{txt}{hline 13}{c +}{hline 57}
{space 7}pop65 {c |}{res}        616    15.27248    2.870348   5.449982   21.71939
{txt}{space 8}male {c |}{res}        616    49.02442    .7925885   46.14389    51.0963
{txt}{space 9}lex {c |}{res}        586    78.60239    2.859304       67.9       83.3
{txt}{space 7}infmo {c |}{res}        583    5.090738    4.187477         .9       40.9
{txt}{space 6}tobaco {c |}{res}        376    1711.806    652.1428        544       4612
{txt}{hline 13}{c +}{hline 57}
{space 6}alcohc {c |}{res}        576    9.856076    2.662264        1.2       14.8
{txt}{space 8}gdpg {c |}{res}        616    2.530686    3.031106   -14.7244   25.55729
{txt}
{com}. 
. gsort phpnh
{txt}
{com}. list phpnh country year in 1/10
{txt}
     {c TLC}{hline 10}{c -}{hline 16}{c -}{hline 6}{c TRC}
     {c |} {res}   phpnh          country   year {txt}{c |}
     {c LT}{hline 10}{c -}{hline 16}{c -}{hline 6}{c RT}
  1. {c |} {res}51.52672          Hungary   1996 {txt}{c |}
  2. {c |} {res}52.19356          Hungary   1998 {txt}{c |}
  3. {c |} {res}52.60734          Hungary   1997 {txt}{c |}
  4. {c |} {res}64.47494          Hungary   1999 {txt}{c |}
  5. {c |} {res}65.02423   Czech Republic   1996 {txt}{c |}
     {c LT}{hline 10}{c -}{hline 16}{c -}{hline 6}{c RT}
  6. {c |} {res}66.84752          Ireland   1996 {txt}{c |}
  7. {c |} {res}67.25144   Czech Republic   1997 {txt}{c |}
  8. {c |} {res}67.72755   Czech Republic   2001 {txt}{c |}
  9. {c |} {res} 67.8392          Ireland   1997 {txt}{c |}
 10. {c |} {res} 68.1692   Czech Republic   2000 {txt}{c |}
     {c BLC}{hline 10}{c -}{hline 16}{c -}{hline 6}{c BRC}

{com}. gsort -phpnh
{txt}
{com}. list phpnh country year in 1/10
{txt}
     {c TLC}{hline 10}{c -}{hline 9}{c -}{hline 6}{c TRC}
     {c |} {res}   phpnh   country   year {txt}{c |}
     {c LT}{hline 10}{c -}{hline 9}{c -}{hline 6}{c RT}
  1. {c |} {res}197.6775    Turkey   2000 {txt}{c |}
  2. {c |} {res}194.6836    Turkey   2001 {txt}{c |}
  3. {c |} {res}188.3962    Turkey   1999 {txt}{c |}
  4. {c |} {res}177.0569    Turkey   2002 {txt}{c |}
  5. {c |} {res}175.7598    Turkey   2004 {txt}{c |}
     {c LT}{hline 10}{c -}{hline 9}{c -}{hline 6}{c RT}
  6. {c |} {res}175.7325    Turkey   2003 {txt}{c |}
  7. {c |} {res}168.4567    Turkey   2005 {txt}{c |}
  8. {c |} {res}160.5305    Turkey   2006 {txt}{c |}
  9. {c |} {res}159.2397    Turkey   1998 {txt}{c |}
 10. {c |} {res}153.1503    Turkey   2007 {txt}{c |}
     {c BLC}{hline 10}{c -}{hline 9}{c -}{hline 6}{c BRC}

{com}. 
. gsort lhl
{txt}
{com}. list lhl country year in 1/10
{txt}
     {c TLC}{hline 10}{c -}{hline 9}{c -}{hline 6}{c TRC}
     {c |} {res}     lhl   country   year {txt}{c |}
     {c LT}{hline 10}{c -}{hline 9}{c -}{hline 6}{c RT}
  1. {c |} {res}2.146441    Turkey   2001 {txt}{c |}
  2. {c |} {res}2.219545    Turkey   2000 {txt}{c |}
  3. {c |} {res}2.322738    Turkey   2004 {txt}{c |}
  4. {c |} {res} 2.36958    Turkey   2002 {txt}{c |}
  5. {c |} {res}2.468435    Turkey   2003 {txt}{c |}
     {c LT}{hline 10}{c -}{hline 9}{c -}{hline 6}{c RT}
  6. {c |} {res}2.546469    Turkey   2005 {txt}{c |}
  7. {c |} {res}2.700357    Turkey   2007 {txt}{c |}
  8. {c |} {res}2.786075    Turkey   2006 {txt}{c |}
  9. {c |} {res} 2.80268    Turkey   2008 {txt}{c |}
 10. {c |} {res}2.824646    Turkey   2009 {txt}{c |}
     {c BLC}{hline 10}{c -}{hline 9}{c -}{hline 6}{c BRC}

{com}. gsort -lhl
{txt}
{com}. list lhl country year in 1/10
{txt}
     {c TLC}{hline 10}{c -}{hline 9}{c -}{hline 6}{c TRC}
     {c |} {res}     lhl   country   year {txt}{c |}
     {c LT}{hline 10}{c -}{hline 9}{c -}{hline 6}{c RT}
  1. {c |} {res}20.12945    Norway   2005 {txt}{c |}
  2. {c |} {res}20.08529    Norway   2006 {txt}{c |}
  3. {c |} {res}20.03193    Norway   2008 {txt}{c |}
  4. {c |} {res}19.88486    Norway   2004 {txt}{c |}
  5. {c |} {res}19.60461    Norway   2007 {txt}{c |}
     {c LT}{hline 10}{c -}{hline 9}{c -}{hline 6}{c RT}
  6. {c |} {res}19.55556    Norway   2003 {txt}{c |}
  7. {c |} {res} 19.3918    Norway   2002 {txt}{c |}
  8. {c |} {res}19.34853    Sweden   1998 {txt}{c |}
  9. {c |} {res}19.07571    Sweden   1999 {txt}{c |}
 10. {c |} {res}18.66164    Sweden   2002 {txt}{c |}
     {c BLC}{hline 10}{c -}{hline 9}{c -}{hline 6}{c BRC}

{com}. 
. gsort prod
{txt}
{com}. list prod country year in 1/10
{txt}
     {c TLC}{hline 9}{c -}{hline 9}{c -}{hline 6}{c TRC}
     {c |} {res}   prod   country   year {txt}{c |}
     {c LT}{hline 9}{c -}{hline 9}{c -}{hline 6}{c RT}
  1. {c |} {res}11.3603   Estonia   2000 {txt}{c |}
  2. {c |} {res}11.7462   Hungary   1995 {txt}{c |}
  3. {c |} {res}11.9728   Hungary   1996 {txt}{c |}
  4. {c |} {res}12.3589   Estonia   2001 {txt}{c |}
  5. {c |} {res}12.3917   Hungary   1997 {txt}{c |}
     {c LT}{hline 9}{c -}{hline 9}{c -}{hline 6}{c RT}
  6. {c |} {res}12.9043   Hungary   1998 {txt}{c |}
  7. {c |} {res}13.0047   Hungary   1999 {txt}{c |}
  8. {c |} {res}13.7713   Estonia   2002 {txt}{c |}
  9. {c |} {res}14.0405   Hungary   2000 {txt}{c |}
 10. {c |} {res}14.5691    Turkey   1999 {txt}{c |}
     {c BLC}{hline 9}{c -}{hline 9}{c -}{hline 6}{c BRC}

{com}. gsort -prod
{txt}
{com}. list prod country year in 1/10
{txt}
     {c TLC}{hline 9}{c -}{hline 12}{c -}{hline 6}{c TRC}
     {c |} {res}   prod      country   year {txt}{c |}
     {c LT}{hline 9}{c -}{hline 12}{c -}{hline 6}{c RT}
  1. {c |} {res}97.5392   Luxembourg   2016 {txt}{c |}
  2. {c |} {res}96.4372   Luxembourg   2015 {txt}{c |}
  3. {c |} {res} 95.831      Ireland   2016 {txt}{c |}
  4. {c |} {res} 94.849   Luxembourg   2014 {txt}{c |}
  5. {c |} {res}94.0433      Ireland   2015 {txt}{c |}
     {c LT}{hline 9}{c -}{hline 12}{c -}{hline 6}{c RT}
  6. {c |} {res}89.7258   Luxembourg   2013 {txt}{c |}
  7. {c |} {res}88.5417       Norway   2013 {txt}{c |}
  8. {c |} {res}86.6573       Norway   2014 {txt}{c |}
  9. {c |} {res}85.6685       Norway   2012 {txt}{c |}
 10. {c |} {res}85.0796   Luxembourg   2012 {txt}{c |}
     {c BLC}{hline 9}{c -}{hline 12}{c -}{hline 6}{c BRC}

{com}. 
. gsort k
{txt}
{com}. list k country year in 1/10
{txt}
     {c TLC}{hline 10}{c -}{hline 15}{c -}{hline 6}{c TRC}
     {c |} {res}       k         country   year {txt}{c |}
     {c LT}{hline 10}{c -}{hline 15}{c -}{hline 6}{c RT}
  1. {c |} {res}  82.671         Hungary   2000 {txt}{c |}
  2. {c |} {res}82.83732   United States   2016 {txt}{c |}
  3. {c |} {res}82.88774         Hungary   2001 {txt}{c |}
  4. {c |} {res}83.16387   United States   2015 {txt}{c |}
  5. {c |} {res} 83.4838   United States   2014 {txt}{c |}
     {c LT}{hline 10}{c -}{hline 15}{c -}{hline 6}{c RT}
  6. {c |} {res}83.58371         Hungary   2016 {txt}{c |}
  7. {c |} {res}83.60327   United States   2010 {txt}{c |}
  8. {c |} {res}83.64188   United States   2011 {txt}{c |}
  9. {c |} {res}83.64493   United States   2012 {txt}{c |}
 10. {c |} {res}83.66218   United States   2009 {txt}{c |}
     {c BLC}{hline 10}{c -}{hline 15}{c -}{hline 6}{c BRC}

{com}. gsort -k
{txt}
{com}. list k country year in 1/10
{txt}
     {c TLC}{hline 10}{c -}{hline 16}{c -}{hline 6}{c TRC}
     {c |} {res}       k          country   year {txt}{c |}
     {c LT}{hline 10}{c -}{hline 16}{c -}{hline 6}{c RT}
  1. {c |} {res} 96.0033       Luxembourg   1995 {txt}{c |}
  2. {c |} {res}95.79909       Luxembourg   1996 {txt}{c |}
  3. {c |} {res}95.30135   United Kingdom   1998 {txt}{c |}
  4. {c |} {res}95.28995   United Kingdom   1997 {txt}{c |}
  5. {c |} {res} 95.2224       Luxembourg   1997 {txt}{c |}
     {c LT}{hline 10}{c -}{hline 16}{c -}{hline 6}{c RT}
  6. {c |} {res}95.14226       Luxembourg   2011 {txt}{c |}
  7. {c |} {res}95.06329       Luxembourg   2007 {txt}{c |}
  8. {c |} {res}95.04109       Luxembourg   2008 {txt}{c |}
  9. {c |} {res} 95.0334   United Kingdom   1995 {txt}{c |}
 10. {c |} {res}95.02216          Denmark   1995 {txt}{c |}
     {c BLC}{hline 10}{c -}{hline 16}{c -}{hline 6}{c BRC}

{com}. 
. gsort pop65
{txt}
{com}. list pop65 country year in 1/10
{txt}
     {c TLC}{hline 10}{c -}{hline 9}{c -}{hline 6}{c TRC}
     {c |} {res}   pop65   country   year {txt}{c |}
     {c LT}{hline 10}{c -}{hline 9}{c -}{hline 6}{c RT}
  1. {c |} {res}5.449982    Turkey   1995 {txt}{c |}
  2. {c |} {res}5.710694    Turkey   1996 {txt}{c |}
  3. {c |} {res}5.988625    Turkey   1997 {txt}{c |}
  4. {c |} {res}  6.2847    Turkey   1998 {txt}{c |}
  5. {c |} {res}6.599882    Turkey   1999 {txt}{c |}
     {c LT}{hline 10}{c -}{hline 9}{c -}{hline 6}{c RT}
  6. {c |} {res}6.677013    Turkey   2003 {txt}{c |}
  7. {c |} {res}6.682733    Turkey   2002 {txt}{c |}
  8. {c |} {res} 6.69007    Turkey   2004 {txt}{c |}
  9. {c |} {res}6.705687    Turkey   2001 {txt}{c |}
 10. {c |} {res}6.724459    Turkey   2005 {txt}{c |}
     {c BLC}{hline 10}{c -}{hline 9}{c -}{hline 6}{c BRC}

{com}. gsort -pop65
{txt}
{com}. list pop65 country year in 1/10
{txt}
     {c TLC}{hline 10}{c -}{hline 10}{c -}{hline 6}{c TRC}
     {c |} {res}   pop65    country   year {txt}{c |}
     {c LT}{hline 10}{c -}{hline 10}{c -}{hline 6}{c RT}
  1. {c |} {res}21.71939      Italy   2016 {txt}{c |}
  2. {c |} {res}21.48352      Italy   2015 {txt}{c |}
  3. {c |} {res}21.36676    Germany   2016 {txt}{c |}
  4. {c |} {res} 21.2304      Italy   2014 {txt}{c |}
  5. {c |} {res}21.15404    Germany   2015 {txt}{c |}
     {c LT}{hline 10}{c -}{hline 10}{c -}{hline 6}{c RT}
  6. {c |} {res}20.94097    Germany   2014 {txt}{c |}
  7. {c |} {res}20.91228      Italy   2013 {txt}{c |}
  8. {c |} {res}20.88438   Portugal   2016 {txt}{c |}
  9. {c |} {res}20.77938    Germany   2013 {txt}{c |}
 10. {c |} {res}20.69889    Germany   2012 {txt}{c |}
     {c BLC}{hline 10}{c -}{hline 10}{c -}{hline 6}{c BRC}

{com}. 
. gsort lex
{txt}
{com}. list lex country year in 1/10
{txt}
     {c TLC}{hline 6}{c -}{hline 9}{c -}{hline 6}{c TRC}
     {c |} {res} lex   country   year {txt}{c |}
     {c LT}{hline 6}{c -}{hline 9}{c -}{hline 6}{c RT}
  1. {c |} {res}67.9   Estonia   1995 {txt}{c |}
  2. {c |} {res}69.3    Turkey   1995 {txt}{c |}
  3. {c |} {res}69.7    Turkey   1996 {txt}{c |}
  4. {c |} {res}69.7   Estonia   1998 {txt}{c |}
  5. {c |} {res}69.9   Estonia   1996 {txt}{c |}
     {c LT}{hline 6}{c -}{hline 9}{c -}{hline 6}{c RT}
  6. {c |} {res}70.1    Turkey   1997 {txt}{c |}
  7. {c |} {res}70.1   Hungary   1995 {txt}{c |}
  8. {c |} {res}70.1   Estonia   1997 {txt}{c |}
  9. {c |} {res}70.3    Turkey   1998 {txt}{c |}
 10. {c |} {res}70.6   Estonia   1999 {txt}{c |}
     {c BLC}{hline 6}{c -}{hline 9}{c -}{hline 6}{c BRC}

{com}. gsort -lex
{txt}
{com}. list lex country year in 1/10
{txt}
     {c TLC}{hline 6}{c -}{hline 13}{c -}{hline 6}{c TRC}
     {c |} {res} lex       country   year {txt}{c |}
     {c LT}{hline 6}{c -}{hline 13}{c -}{hline 6}{c RT}
  1. {c |} {res}83.3         Spain   2014 {txt}{c |}
  2. {c |} {res}83.3   Switzerland   2014 {txt}{c |}
  3. {c |} {res}83.2         Italy   2014 {txt}{c |}
  4. {c |} {res}83.2         Spain   2013 {txt}{c |}
  5. {c |} {res}  83       Iceland   2012 {txt}{c |}
     {c LT}{hline 6}{c -}{hline 13}{c -}{hline 6}{c RT}
  6. {c |} {res}  83   Switzerland   2015 {txt}{c |}
  7. {c |} {res}  83         Spain   2015 {txt}{c |}
  8. {c |} {res}82.9   Switzerland   2013 {txt}{c |}
  9. {c |} {res}82.9       Iceland   2014 {txt}{c |}
 10. {c |} {res}82.8   Switzerland   2012 {txt}{c |}
     {c BLC}{hline 6}{c -}{hline 13}{c -}{hline 6}{c BRC}

{com}. 
. gsort infmo
{txt}
{com}. list infmo country year in 1/10
{txt}
     {c TLC}{hline 7}{c -}{hline 12}{c -}{hline 6}{c TRC}
     {c |} {res}infmo      country   year {txt}{c |}
     {c LT}{hline 7}{c -}{hline 12}{c -}{hline 6}{c RT}
  1. {c |} {res}   .9      Iceland   2011 {txt}{c |}
  2. {c |} {res}  1.1      Iceland   2012 {txt}{c |}
  3. {c |} {res}  1.4      Iceland   2006 {txt}{c |}
  4. {c |} {res}  1.6     Slovenia   2012 {txt}{c |}
  5. {c |} {res}  1.6     Slovenia   2015 {txt}{c |}
     {c LT}{hline 7}{c -}{hline 12}{c -}{hline 6}{c RT}
  6. {c |} {res}  1.7      Finland   2015 {txt}{c |}
  7. {c |} {res}  1.8   Luxembourg   2008 {txt}{c |}
  8. {c |} {res}  1.8      Finland   2013 {txt}{c |}
  9. {c |} {res}  1.8      Iceland   2013 {txt}{c |}
 10. {c |} {res}  1.8     Slovenia   2014 {txt}{c |}
     {c BLC}{hline 7}{c -}{hline 12}{c -}{hline 6}{c BRC}

{com}. gsort -infmo
{txt}
{com}. list infmo country year in 1/10
{txt}
     {c TLC}{hline 7}{c -}{hline 9}{c -}{hline 6}{c TRC}
     {c |} {res}infmo   country   year {txt}{c |}
     {c LT}{hline 7}{c -}{hline 9}{c -}{hline 6}{c RT}
  1. {c |} {res} 40.9    Turkey   1996 {txt}{c |}
  2. {c |} {res} 38.8    Turkey   1997 {txt}{c |}
  3. {c |} {res} 36.5    Turkey   1998 {txt}{c |}
  4. {c |} {res} 33.9    Turkey   1999 {txt}{c |}
  5. {c |} {res} 29.6    Turkey   2002 {txt}{c |}
     {c LT}{hline 7}{c -}{hline 9}{c -}{hline 6}{c RT}
  6. {c |} {res} 29.1    Turkey   2003 {txt}{c |}
  7. {c |} {res} 28.6    Turkey   2001 {txt}{c |}
  8. {c |} {res} 28.4    Turkey   2000 {txt}{c |}
  9. {c |} {res} 27.4    Turkey   2004 {txt}{c |}
 10. {c |} {res} 25.8    Turkey   2005 {txt}{c |}
     {c BLC}{hline 7}{c -}{hline 9}{c -}{hline 6}{c BRC}

{com}. 
. gsort tobaco
{txt}
{com}. list tobaco country year in 1/10
{txt}
     {c TLC}{hline 8}{c -}{hline 16}{c -}{hline 6}{c TRC}
     {c |} {res}tobaco          country   year {txt}{c |}
     {c LT}{hline 8}{c -}{hline 16}{c -}{hline 6}{c RT}
  1. {c |} {res}   544          Finland   2012 {txt}{c |}
  2. {c |} {res}   567          Finland   2009 {txt}{c |}
  3. {c |} {res}   600      New Zealand   2016 {txt}{c |}
  4. {c |} {res}   629      New Zealand   2015 {txt}{c |}
  5. {c |} {res} 662.4      New Zealand   2014 {txt}{c |}
     {c LT}{hline 8}{c -}{hline 16}{c -}{hline 6}{c RT}
  6. {c |} {res} 702.1      New Zealand   2013 {txt}{c |}
  7. {c |} {res} 702.4   United Kingdom   2015 {txt}{c |}
  8. {c |} {res} 739.4   United Kingdom   2014 {txt}{c |}
  9. {c |} {res} 757.5      New Zealand   2012 {txt}{c |}
 10. {c |} {res}   761          Finland   2005 {txt}{c |}
     {c BLC}{hline 8}{c -}{hline 16}{c -}{hline 6}{c BRC}

{com}. gsort -tobaco
{txt}
{com}. list tobaco country year in 1/10
{txt}
     {c TLC}{hline 8}{c -}{hline 9}{c -}{hline 6}{c TRC}
     {c |} {res}tobaco   country   year {txt}{c |}
     {c LT}{hline 8}{c -}{hline 9}{c -}{hline 6}{c RT}
  1. {c |} {res}  4612    Greece   2009 {txt}{c |}
  2. {c |} {res}  4000    Greece   2010 {txt}{c |}
  3. {c |} {res}  3741    Greece   2004 {txt}{c |}
  4. {c |} {res}  3674    Greece   2007 {txt}{c |}
  5. {c |} {res}  3663    Greece   2001 {txt}{c |}
     {c LT}{hline 8}{c -}{hline 9}{c -}{hline 6}{c RT}
  6. {c |} {res}  3639    Greece   2005 {txt}{c |}
  7. {c |} {res}  3538    Greece   2003 {txt}{c |}
  8. {c |} {res}  3503    Greece   2006 {txt}{c |}
  9. {c |} {res}  3491    Greece   2011 {txt}{c |}
 10. {c |} {res}  3488    Greece   2000 {txt}{c |}
     {c BLC}{hline 8}{c -}{hline 9}{c -}{hline 6}{c BRC}

{com}. 
. gsort alcohc
{txt}
{com}. list alcohc country year in 1/10
{txt}
     {c TLC}{hline 8}{c -}{hline 9}{c -}{hline 6}{c TRC}
     {c |} {res}alcohc   country   year {txt}{c |}
     {c LT}{hline 8}{c -}{hline 9}{c -}{hline 6}{c RT}
  1. {c |} {res}   1.2    Turkey   2006 {txt}{c |}
  2. {c |} {res}   1.3    Turkey   2005 {txt}{c |}
  3. {c |} {res}   1.3    Turkey   2007 {txt}{c |}
  4. {c |} {res}   1.4    Turkey   2015 {txt}{c |}
  5. {c |} {res}   1.4    Turkey   2001 {txt}{c |}
     {c LT}{hline 8}{c -}{hline 9}{c -}{hline 6}{c RT}
  6. {c |} {res}   1.4    Turkey   2013 {txt}{c |}
  7. {c |} {res}   1.4    Turkey   2004 {txt}{c |}
  8. {c |} {res}   1.4    Turkey   2002 {txt}{c |}
  9. {c |} {res}   1.5    Turkey   2010 {txt}{c |}
 10. {c |} {res}   1.5    Turkey   2011 {txt}{c |}
     {c BLC}{hline 8}{c -}{hline 9}{c -}{hline 6}{c BRC}

{com}. gsort -alcohc
{txt}
{com}. list alcohc country year in 1/10
{txt}
     {c TLC}{hline 8}{c -}{hline 10}{c -}{hline 6}{c TRC}
     {c |} {res}alcohc    country   year {txt}{c |}
     {c LT}{hline 8}{c -}{hline 10}{c -}{hline 6}{c RT}
  1. {c |} {res}  14.8    Estonia   2007 {txt}{c |}
  2. {c |} {res}  14.5     France   1996 {txt}{c |}
  3. {c |} {res}  14.5     France   1998 {txt}{c |}
  4. {c |} {res}  14.5    Ireland   2001 {txt}{c |}
  5. {c |} {res}  14.5     France   1995 {txt}{c |}
     {c LT}{hline 8}{c -}{hline 10}{c -}{hline 6}{c RT}
  6. {c |} {res}  14.4     France   1999 {txt}{c |}
  7. {c |} {res}  14.3     France   1997 {txt}{c |}
  8. {c |} {res}  14.3    Ireland   2002 {txt}{c |}
  9. {c |} {res}  14.2   Portugal   2003 {txt}{c |}
 10. {c |} {res}  14.2    Estonia   2008 {txt}{c |}
     {c BLC}{hline 8}{c -}{hline 10}{c -}{hline 6}{c BRC}

{com}. 
. foreach v of varlist (lhl phpnh prod k pop14 pop65 male lex infmo tobaco alcohc gdpg) {c -(}
{txt}  2{com}. bysort cid: egen avg_`v' = mean(`v')
{txt}  3{com}. gen dm`v' = `v' - avg_`v'
{txt}  4{com}. drop avg_`v'
{txt}  5{com}. {c )-}
{txt}(22 missing values generated)
(224 missing values generated)
(66 missing values generated)
(113 missing values generated)
(22 missing values generated)
(31 missing values generated)
(14 missing values generated)
(30 missing values generated)
(33 missing values generated)
(154 missing values generated)
(240 missing values generated)
(40 missing values generated)

{com}. 
. summarize dmphpnh dmlhl dmprod dmk dmpop14 dmpop65 dmmale dmlex dminfmo dmtobaco dmalcohc dmgdpg

{txt}    Variable {c |}        Obs        Mean    Std. Dev.       Min        Max
{hline 13}{c +}{hline 57}
{space 5}dmphpnh {c |}{res}        503   -1.08e-06    10.36471  -44.76262   52.91487
{txt}{space 7}dmlhl {c |}{res}        392    1.02e-07    .8188999  -2.269024   3.883756
{txt}{space 6}dmprod {c |}{res}        585    2.84e-07    10.70775  -29.73113   45.20023
{txt}{space 9}dmk {c |}{res}        602    6.46e-07     1.44018  -5.611732    4.26413
{txt}{space 5}dmpop14 {c |}{res}        616    1.81e-07    1.165389  -4.012461   4.695976
{txt}{hline 13}{c +}{hline 57}
{space 5}dmpop65 {c |}{res}        616    9.60e-08    1.271996   -3.20219   4.131596
{txt}{space 6}dmmale {c |}{res}        616    1.11e-07    .1766486  -.5705032   .8435402
{txt}{space 7}dmlex {c |}{res}        586    6.90e-07    1.647294  -5.209518    4.89048
{txt}{space 5}dminfmo {c |}{res}        583    3.01e-08    2.242489    -12.165     18.035
{txt}{space 4}dmtobaco {c |}{res}        376    6.49e-06    295.7332  -794.7953   1136.714
{txt}{hline 13}{c +}{hline 57}
{space 4}dmalcohc {c |}{res}        576   -3.79e-08    .8508483  -3.052381   3.847619
{txt}{space 6}dmgdpg {c |}{res}        616    1.53e-08    2.792541  -18.88679   19.55779
{txt}
{com}. 
. log close
      {txt}name:  {res}<unnamed>
       {txt}log:  {res}\\file\UsersW$\wrr15\Home\My Documents\My Files\ATANDA AKINWANDE\BCD PAPER\HEALTH ECONOMICS revision\NEW DATA AND PROGRAMS (20171021)\TABLE1.smcl
  {txt}log type:  {res}smcl
 {txt}closed on:  {res} 9 Nov 2017, 09:54:22
{txt}{.-}
{smcl}
{txt}{sf}{ul off}